[dbo].[RFMMain]

Property	Value
Row Count	220
Created	10:31:35 AM Tuesday, March 02, 2010
Last Modified	11:40:07 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key PK_RFMMain: RFMKey\ContactKey$	RFMKey	uniqueidentifier	16
$Cluster Primary Key PK_RFMMain: RFMKey\ContactKey$	ContactKey	uniqueidentifier	16
	Recency	int	4	((0))
	Frequency	int	4	((0))
	Monetary	int	4	((0))
	Combined	int	4	((0))
	Total	int	4	((0))
	LowAmount	decimal(18,4)	9	((0))
	HighAmount	decimal(18,4)	9	((0))
	TotalAmount	decimal(18,4)	9	((0))
	NumDays	int	4
	NumContacts	int	4	((0))
	FirstContact	datetime	8
	LastContact	datetime	8
	HighContact	datetime	8
	FirstContactAmount	decimal(18,0)	9
	LastContactAmount	decimal(18,0)	9

	Name	Columns	Unique
$Cluster Primary Key PK_RFMMain: RFMKey\ContactKey$	PK_RFMMain	RFMKey, ContactKey
	IX_RFMMain_UserKey	ContactKey

Name	Columns
FK_RFMMain_ContactMain	ContactKey->[dbo].[ContactMain].[ContactKey]

SQL Script

CREATE TABLE [dbo].[RFMMain]
(
[RFMKey] [uniqueidentifier] NOT NULL,
[ContactKey] [uniqueidentifier] NOT NULL,
[Recency] [int] NULL CONSTRAINT [DF_RFMMain_Recency] DEFAULT ((0)),
[Frequency] [int] NULL CONSTRAINT [DF_RFMMain_Frequency] DEFAULT ((0)),
[Monetary] [int] NULL CONSTRAINT [DF_RFMMain_Monetary] DEFAULT ((0)),
[Combined] [int] NULL CONSTRAINT [DF_RFMMain_Combined] DEFAULT ((0)),
[Total] [int] NULL CONSTRAINT [DF_RFMMain_Total] DEFAULT ((0)),
[LowAmount] [decimal] (18, 4) NULL CONSTRAINT [DF_RFMMain_LowAmount] DEFAULT ((0)),
[HighAmount] [decimal] (18, 4) NULL CONSTRAINT [DF_RFMMain_HighAmount] DEFAULT ((0)),
[TotalAmount] [decimal] (18, 4) NULL CONSTRAINT [DF_RFMMain_TotalAmount] DEFAULT ((0)),
[NumDays] [int] NULL,
[NumContacts] [int] NULL CONSTRAINT [DF_RFMMain_NumContacts] DEFAULT ((0)),
[FirstContact] [datetime] NULL,
[LastContact] [datetime] NULL,
[HighContact] [datetime] NULL,
[FirstContactAmount] [decimal] (18, 0) NULL,
[LastContactAmount] [decimal] (18, 0) NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[RFMMain] ADD CONSTRAINT [PK_RFMMain] PRIMARY KEY CLUSTERED ([RFMKey], [ContactKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_RFMMain_UserKey] ON [dbo].[RFMMain] ([ContactKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RFMMain] ADD CONSTRAINT [FK_RFMMain_ContactMain] FOREIGN KEY ([ContactKey]) REFERENCES [dbo].[ContactMain] ([ContactKey])
GO